Learn more

About vendor pricing

Updating part prices

Note: This functionality is available only if you have the Estimating Module.

Caution! Always make a backup of your data before you add parts or update prices.

Before updating part prices

Consider the following points:

  • Updating only requires a Part#.
  • You can remove field mapping for a specific row by selecting the Destination Field and using the right arrow key to move it back to the Destination Fields list.
  • The part numbers from the vendor's source file must match the Part# in Sage 100 Contractor in order for the update to properly occur.

To update part prices:

  1. Open 9-6 Add Parts/Update Prices.

  2. Select Update Part Prices and complete the following as necessary:

  3. If you want Sage 100 Contractor to match parts based on the Alpha Part#, select Match Alpha Part#.

  4. Default Cost/Billing Amount is selected by default. Sage 100 Contractor updates the default cost/billing amount for parts in the database.

    Note: Vendor-specific prices will not be applied to new parts but will be applied to Default Cost/Billing Amount.

  5. If you want Sage 100 Contractor to update the Vendor Price instead of the Default Cost/Billing Amount of the 9-2 Parts window, select Vendor Price.

  6. If you selected Vendor Price as your update method, from the dropdown list, select the vendor whose source file you are using.

    The path name for the source file appears in the window.

  7. Choose Select Source File, browse, and then select the database file to use for adding parts.

    The Source File Fields under Field Mapping appears.

  8. If the source file contains descriptive headers or labels as its first line, select First Line is Header.

    This line is ignored during the import function.

  9. Map the Destination Fields from the Sage 100 Contractor database that correspond to the imported Source File Fields.
    1. On the left side of the window, under Field Mapping, select the Source File Fields row and the Destination Fields cell that you want to map.
    2. Under Destination Fields on the right side of the window, select the corresponding Sage 100 Contractor field by double-clicking the field. Alternately, select the Sage 100 Contractor field and then select ENTER or the arrow key to map the field.

    Repeat step 9 until you have mapped all fields you want to import to Sage 100 Contractor from the external database.

  10. Click Add/Update.

If any failures occur during the process, an error log appears for your review.

Tip: You can use your selections to save as a template for future use.